﻿SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[dummy](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[value1] [numeric](15, 0) NOT NULL CONSTRAINT [DF_dummy_value1]  DEFAULT ((0)),
	[value2] [int] NOT NULL CONSTRAINT [DF_dummy_value2]  DEFAULT ((0)),
	[value3] [numeric](18, 4) NOT NULL CONSTRAINT [DF_dummy_value3]  DEFAULT ((0)),
	[value4] [varchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_dummy] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF